BEGIN TRANSACTION GO ALTER TABLE dbo.Invoice_GDN ADD NoOfContainers decimal(11, 2) NOT NULL CONSTRAINT DF_Invoice_GDN_NoOfContainers DEFAULT 0 GO COMMIT ------------------------------------------------------------------